<?php
include ("top.php");
?>
<table width="766" height="438" border="0" align="center"
	cellpadding="0" cellspacing="0">
	<tr>
		<td width="209" height="438" valign="top" bgcolor="#F0F0F0"><?php include("left.php");?></td>
		<td width="581" align="center" valign="top" bgcolor="#FFFFFF"><table
				width="550" height="20" border="0" align="center" cellpadding="0"
				cellspacing="0">
				<tr>
					<td>
						<div align="left"> &nbsp;
	                	<?php											
						$sql = mysqli_query ( $conn, "select * from tb_type order by id desc");
						//var_dump($sql);exit();
						$info = mysqli_fetch_object ( $sql );
						//var_dump($info);exit();
						if ($info == false) {
							echo "暂无房品!";
						} else {
							do {
							echo "<a href='showfenlei.php?id=" . $info->id . "'>" . $info->typename . "&nbsp;</a>";
						} while ( $info = mysqli_fetch_object ( $sql ) );
						}
						?>
	        			</div>
        			</td>
				</tr>
			</table>
      <?php
						if ($_GET ["id"] == "") {
							$sql = mysqli_query ( $conn, "select * from tb_type order by id desc limit 0,1" );
							$info = mysqli_fetch_array ( $sql );
							$id = $info ["id"];
						} else {
							$id = $_GET ["id"];
						}
						$sql1 = mysqli_query ( $conn, "select * from tb_type where id=" . $id . "" );
						$info1 = mysqli_fetch_array ( $sql1 );
						
						$sql = mysqli_query ( $conn, "select count(*) as total from tb_shangpin where typeid='" . $id . "' order by addtime desc " );
						$info = mysqli_fetch_array ( $sql );
						$total = $info ["total"];
						if ($total == 0) {
							echo "<div align='center'>本站暂无该类房品!</div>";
						} else {
							?>
      <table width="550" height="25" border="0" align="center"
				cellpadding="0" cellspacing="0">
				<tr>
					<td bgcolor="#FEE7C5"><div align="left">
							<span style="color: #666666; font-weight: bold"><span
								style="color: #000000">&nbsp;本类房品&gt;&gt;</span><?php echo $info1["typename"];?></span>
						</div></td>
				</tr>
			</table>
			<table width="550" height="10" border="0" align="center"
				cellpadding="0" cellspacing="0">
				<tr>
					<td background="images/line1.gif"></td>
				</tr>
			</table>
			<table width="550" height="70" border="0" align="center"
				cellpadding="0" cellspacing="0">
        <?php
							$pagesize = 3;
							if ($total <= $pagesize) {
								$pagecount = 1;
							}
							if (($total % $pagesize) != 0) {
								$pagecount = intval ( $total / $pagesize ) + 1;
							} else {
								$pagecount = $total / $pagesize;
							}
							if (($_GET ["page"]) == "") {
								$page = 1;
							} else {
								$page = intval ( $_GET ["page"] );
							}
							
							$sql1 = mysqli_query ( $conn, "select * from tb_shangpin where typeid=" . $id . " order by addtime desc limit " . ($page - 1) * $pagesize . ",$pagesize " );
							while ( $info1 = mysqli_fetch_array ( $sql1 ) ) {
								?>
        <tr>
					<td width="89" rowspan="6"><div align="center">
              <?php
								if ($info1 ["tupian"] == "") {
									echo "暂无图片!";
								} else {
									?>
              <a href="lookinfo.php?id=<?php echo $info1["id"];?>"><img
								border="0" width="80" height="80"
								src="<?php echo $info1["tupian"];?>"></a>
              <?php
								}
								?>
          </div></td>
					<td width="93" height="20"><div align="center"
							style="color: #000000">名称：</div></td>
					<td colspan="5"><div align="left">
							<a href="lookinfo.php?id=<?php echo $info1["id"];?>"><?php echo $info1["mingcheng"];?></a>
						</div></td>
				</tr>
				<tr>
					<td width="93" height="20"><div align="center"
							style="color: #000000">类型：</div></td>
					<td width="101" height="20"><div align="left"><?php echo $info1["xinghao"];?></div></td>
					<td width="62"><div align="center" style="color: #000000">剩余数量:</div></td>
					<td colspan="3"><div align="left"><?php echo $info1["shuliang"];?></div></td>
				</tr>
				<tr>
					<td height="20"><div align="center" style="color: #000000">原价：</div></td>
					<td height="20"><div align="left"><?php echo $info1["shichangjia"];?>元</div></td>
					<td height="20"><div align="center" style="color: #000000">&nbsp;会员价：</div></td>
					<td height="20"><div align="left"><?php echo $info1["huiyuanjia"];?>元</div></td>
					<td height="20"><div align="center" style="color: #000000">折扣：</div></td>
					<td height="20"><div align="left"><?php echo (ceil(($info1["huiyuanjia"]/$info1["shichangjia"])*100))."%";?></div></td>
				</tr>
				<tr>
					<td width="93" height="20"><div align="center"
							style="color: #000000">简介：</div></td>
					<td height="20" colspan="5"><div align="left"><?php echo $info1["jianjie"];?></div></td>
				</tr>
				<tr>
					<td height="20" colspan="6" width="461"><div align="center">
							&nbsp;&nbsp;&nbsp;&nbsp;<a
								href="addgouwuche.php?id=<?php echo $info1["id"];?>"><img
								src="images/goumai_btn.gif" width="60" height="18" border="0"
								style="cursor: hand"></a>
						</div></td>
				</tr>
				<tr>
					<td height="10" colspan="7" background="images/line1.gif"></td>
				</tr>
        <?php
							}
							
							?>
      </table>
			<table width="550" height="25" border="0" align="center"
				cellpadding="0" cellspacing="0">
				<tr>
					<td><div align="right"> &nbsp;本站共有该类房品&nbsp;
                  <?php
							echo $total;
							?>
&nbsp;种&nbsp;每页显示&nbsp;<?php echo $pagesize;?>&nbsp;种&nbsp;第&nbsp;<?php echo $page;?>&nbsp;页/共&nbsp;<?php echo $pagecount; ?>&nbsp;页
        <?php
							if ($page >= 2) {
								?>
        <a href="showfenlei.php?id=<?php echo $id;?>&page=1" title="首页"><font
								face="webdings"> 9 </font></a> <a
								href="showfenlei.php?id=<?php echo $id;?>&page=<?php echo $page-1;?>"
								title="前一页"><font face="webdings"> 7 </font></a>
        <?php
							}
							if ($pagecount <= 4) {
								for($i = 1; $i <= $pagecount; $i ++) {
									?>
        <a
								href="showfenlei.php?id=<?php echo $id;?>&page=<?php echo $i;?>"><?php echo $i;?></a>
        <?php
								}
							} else {
								for($i = 1; $i <= 4; $i ++) {
									?>
        <a
								href="showfenlei.php?id=<?php echo $id;?>&page=<?php echo $i;?>"><?php echo $i;?></a>
        <?php }?>
        <a
								href="showfenlei.php?id=<?php echo $id;?>&page=<?php echo $page-1;?>"
								title="后一页"><font face="webdings"> 8 </font></a> <a
								href="showfenlei.php?id=<?php echo $id;?>&page=<?php echo $pagecount;?>"
								title="尾页"><font face="webdings"> : </font></a>
        <?php }?>
          </div></td>
				</tr>
			</table>
    <?php
						}
						
						?>	</td>
	</tr>
</table>
<?php
 include("bottom.php");
?>